package com.open.capacity.salary.dto;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.handler.inter.IExcelDataModel;
import cn.afterturn.easypoi.handler.inter.IExcelModel;
import lombok.Data;
import org.hibernate.validator.constraints.NotBlank;

import java.math.BigDecimal;
import java.util.Date;


@Data
public class RecordTaxExcelModel implements IExcelDataModel, IExcelModel {
    //行号
    private Integer rowNum;
    //错误消息
    private String errorMsg;

    @Excel(name = "部门名称",width = 15)
    private String departmentName;

    @Excel(name = "员工编号",width = 10)
    private String userCode;

    @Excel(name = "员工姓名",width = 15)
    private String userName;

    private String category;

    @Excel(name = "收入是否含税", replace = {"含税_1", "不含税_0","_null"})
    private Integer isIncludeTax;

    @Excel(name = "工资",width = 15)
    private BigDecimal salary;

    @Excel(name = "奖金1",width = 15)
    private BigDecimal bonus1;

    @Excel(name = "奖金2",width = 15)
    private BigDecimal bonus2;

    @Excel(name = "奖金3",width = 15)
    private BigDecimal bonus3;

    @Excel(name = "奖金4",width = 15)
    private BigDecimal bonus4;

    @Excel(name = "奖金5",width = 15)
    private BigDecimal bonus5;

    @Excel(name = "收入合计",width = 15)
    private BigDecimal income;

    @Excel(name = "扣社保费",width = 15)
    private BigDecimal socialSecurityFund;

    @Excel(name = "扣公积金",width = 15)
    private BigDecimal accumulationFund1;

    @Excel(name = "扣公积金2",width = 15)
    private BigDecimal accumulationFund2;

    @Excel(name = "公积金实际扣费",width = 15)
    private BigDecimal accumulationMoney;

    @Excel(name = "扣医疗保险",width = 15)
    private BigDecimal healthInsurance;

    @Excel(name = "扣养老保险",width = 15)
    private BigDecimal endowmentInsurance;

    @Excel(name = "扣其他",width = 15)
    private BigDecimal other;

    @Excel(name = "扣允许费用额",width = 15)
    private BigDecimal allowFee;

    @Excel(name = "扣捐赠费",width = 15)
    private BigDecimal donate;

    @Excel(name = "扣款合计",width = 15)
    private BigDecimal cutTotal;

    @Excel(name = "应纳所得税额",width = 15)
    private BigDecimal taxableIncome;

    @Excel(name = "税率",width = 15)
    private BigDecimal tax;

    @Excel(name = "扣除数",width = 15)
    private BigDecimal deduction;

    @Excel(name = "应纳税额",width = 15)
    private BigDecimal taxAmount;

    @Excel(name = "减免税额",width = 15)
    private BigDecimal taxDeduction;

    @Excel(name = "财政预扣税额",width = 15)
    private BigDecimal fiscalCut;

    @Excel(name = "单位预扣税额",width = 15)
    private BigDecimal companyCut;

    @Excel(name = "补扣税",width = 15)
    private BigDecimal fillTax;

    @Excel(name = "实际纳税额",width = 15)
    private BigDecimal actualTax;

}
